Key points
When adding and organizing tables and fields in the View Tab, keep in mind the following points:
- Tables are not displayed to the dictionary user as database tables. Table names become field headings. These headings appear just like tables when the user designs a report based on your dictionary. However, field headings do not necessarily represent database tables that actually exist.
- Field headings can be added anywhere in the Headings & fields in View list box to provide clearer organization of data for your users. See Adding a new field heading.
- Fields can be added to the View list box as many times as necessary. A field does not have to appear under a field heading that matches the table the field exists in. Organize fields in any order and under any field headings that will work best for your users.
- Fields must be grouped under field headings. If you add a single field to the Headings & fields in View list box and no field heading appears in the list box (the list box is empty), the application will provide a default field heading for you and will add the field you selected underneath that heading.
- Field names and field headings that appear in the Headings & fields in View list box can be renamed to anything you want. See Renaming fields, field headings, and formulas.